﻿using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Nucleic.Core.DoMain
{
    /// <summary>
    /// 预约信息表
    /// </summary>
    [SugarTable("book_info")]

    public class book_info
    {

        /// <summary>
        /// 预约信息唯一id,患者出示的二维码既是该值
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]

        public int appo_id { get; set; }

        public string orders_id { get; set; }


        public int pat_id { get; set; }

        /// <summary>
        /// 预约信息保存时间
        /// </summary>
        public DateTime ins_time { get; set; }

        /// <summary>
        /// 预约日期(即核算检测日期)
        /// </summary>
        public DateTime appo_date { get; set; }

        /// <summary>
        /// 预约时段
        /// </summary>
        public int range_id { get; set; }

        /// <summary>
        /// 检测项目主表id(check_item.item_id)
        /// </summary>
        public string item_id { get; set; }

        /// <summary>
        /// 流调表id
        /// </summary>
        public int inves_id { get; set; }

        public DateTime update_time { get; set; }

        /// <summary>
        /// 0=预约中,1=线上已缴费,2=社保卡已缴费,3=已采样,4=退费作废,5=超期作废,6=无法采集
        /// </summary>
        public string status { get; set; }

    }
}
